Tabela LBenefitPlanServDiscount

Definicja tabeli LBenefitPlanServDiscount

Name

LBenefitPlanServDiscount

Code

LBenefitPlanServDiscount

Comment

Informacje o rabatach do benefitplanów


Lista kolumn tabeli LBenefitPlanServDiscount

Name

Code

LBenefitPlanServiceDiscountID

LBenefitPlanServiceDiscountID

LBenefitPlanServID

LBenefitPlanServID

ContractorDiscount

ContractorDiscount

StartDT

StartDT

StopDT

StopDT

StartT

StartT

StopT

StopT

MondayActive

MondayActive

TuesdayActive

TuesdayActive

WednesdayActive

WednesdayActive

ThursdayActive

ThursdayActive

FridayActive

FridayActive

SaturdayActive

SaturdayActive

SundayActive

SundayActive


Kolumna LBenefitPlanServiceDiscountID tabeli LBenefitPlanServDiscount

Definicja kolumny LBenefitPlanServiceDiscountID tabeli LBenefitPlanServDiscount

Name

LBenefitPlanServiceDiscountID

Code

LBenefitPlanServiceDiscountID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID informacji o rabatach do benefitplanów


Kolumna LBenefitPlanServID tabeli LBenefitPlanServDiscount

Definicja kolumny LBenefitPlanServID tabeli LBenefitPlanServDiscount

Name

LBenefitPlanServID

Code

LBenefitPlanServID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ContractorDiscount tabeli LBenefitPlanServDiscount

Definicja kolumny ContractorDiscount tabeli LBenefitPlanServDiscount

Name

ContractorDiscount

Code

ContractorDiscount

Data Type

NUMBER(7,6)

Mandatory

Yes

Comment

Procentowa znizka


Kolumna StartDT tabeli LBenefitPlanServDiscount

Definicja kolumny StartDT tabeli LBenefitPlanServDiscount

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

Yes

Comment

Data poczatku obowiazywania


Kolumna StopDT tabeli LBenefitPlanServDiscount

Definicja kolumny StopDT tabeli LBenefitPlanServDiscount

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

Yes

Comment

Data konca obowiazywania


Kolumna StartT tabeli LBenefitPlanServDiscount

Definicja kolumny StartT tabeli LBenefitPlanServDiscount

Name

StartT

Code

StartT

Data Type

DATE

Mandatory

No

Comment

Godzina poczatku obowiazywania kazdego dnia


Kolumna StopT tabeli LBenefitPlanServDiscount

Definicja kolumny StopT tabeli LBenefitPlanServDiscount

Name

StopT

Code

StopT

Data Type

DATE

Mandatory

No

Comment

Godzina konca obowiazywania kazdego dnia


Kolumna MondayActive tabeli LBenefitPlanServDiscount

Definicja kolumny MondayActive tabeli LBenefitPlanServDiscount

Name

MondayActive

Code

MondayActive

Data Type

NUMBER(3)

Mandatory

No

Comment

Flaga aktywnosci w dniu tygodnia


Kolumna TuesdayActive tabeli LBenefitPlanServDiscount

Definicja kolumny TuesdayActive tabeli LBenefitPlanServDiscount

Name

TuesdayActive

Code

TuesdayActive

Data Type

NUMBER(3)

Mandatory

No

Comment

Flaga aktywnosci w dniu tygodnia


Kolumna WednesdayActive tabeli LBenefitPlanServDiscount

Definicja kolumny WednesdayActive tabeli LBenefitPlanServDiscount

Name

WednesdayActive

Code

WednesdayActive

Data Type

NUMBER(3)

Mandatory

No

Comment

Flaga aktywnosci w dniu tygodnia


Kolumna ThursdayActive tabeli LBenefitPlanServDiscount

Definicja kolumny ThursdayActive tabeli LBenefitPlanServDiscount

Name

ThursdayActive

Code

ThursdayActive

Data Type

NUMBER(3)

Mandatory

No

Comment

Flaga aktywnosci w dniu tygodnia


Kolumna FridayActive tabeli LBenefitPlanServDiscount

Definicja kolumny FridayActive tabeli LBenefitPlanServDiscount

Name

FridayActive

Code

FridayActive

Data Type

NUMBER(3)

Mandatory

No

Comment

Flaga aktywnosci w dniu tygodnia


Kolumna SaturdayActive tabeli LBenefitPlanServDiscount

Definicja kolumny SaturdayActive tabeli LBenefitPlanServDiscount

Name

SaturdayActive

Code

SaturdayActive

Data Type

NUMBER(3)

Mandatory

No

Comment

Flaga aktywnosci w dniu tygodnia


Kolumna SundayActive tabeli LBenefitPlanServDiscount

Definicja kolumny SundayActive tabeli LBenefitPlanServDiscount

Name

SundayActive

Code

SundayActive

Data Type

NUMBER(3)

Mandatory

No

Comment

Flaga aktywnosci w dniu tygodnia


Lista kluczy tabeli LBenefitPlanServDiscount

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LBenefitPlanServDiscount

Definicja klucza Identifier_1 tabeli LBenefitPlanServDiscount

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment